inner join
- 网络内部联接;内连接;内联;等值连接;内链接;自然连接
-
You join two tables by using an inner join or an outer join .
可以通过使用内连接或外连接来连接两个表。
-
An inner join is essentially the intersection of two tables , where the tables are matched by comparing the values of a key column , such as itemNumber .
内连接实际上是两个表的交集,它通过比较关键列(比如itemNumber)的值来匹配表。
-
Remember , these are counts for INNER join .
记住,这些是内连接(INNERJOIN)的计数。
-
For example when using an INNER JOIN you compare two columns of different tables and test for equality .
例如,在使用INNERJOIN时,比较不同表的两个列,检查它们是否相等。
-
INNER JOIN versus tables strung together in the FROM clause separated by commas
INNERJOINvsFROM子句中串在一起并用逗号分隔的表
-
J is an inner join .
J是一个内部连接。
-
This inner join is known as an equi-join .
此内部联接称为同等联接。
-
For the merge statement that contains only the update clause or the delete clause , the inner join is performed between source and target table .
对于仅包含更新子句或删除子句的merge语句,内部联接会在源表与目标表之间执行。
-
This example uses a SELECT query that defines the inner join between WordFrequency and Companies , where the word matches the name of the company .
本例使用SELECT查询,它定义了WordFrequency和Companies之间的innerjoin,其中单词与公司名匹配。
-
The merge statement first does a join ( outer join or inner join , depending on the merge statement ) between source and target table rows .
merge语句首先进行(外部联接或者内部联接,取决于merge语句)源与目标表行之间的联接。
-
Since this is an inner join , this view has no rows for records that appear in wells but not in wells_pts ( because they have null or invalid coordinates ) .
因为这是一个内联结,所以这个视图不包含出现在wells表中但没有出现在wellspts表中的记录(因为这些记录具有空的或无效的坐标)。
-
That is , the inner table of the join operation will be scanned eight times , once for each of the eight qualifying records from the outer input .
也就是说,联接操作的内部表将被扫描8次,来自外部输入的8个合格的记录每个都将被扫描一次。
-
Having mentioned possible collisions between the outer and the inner legs of a join , it should also be mentioned that a similar problem could occur between the function and the INSERT operation .
提到连接的内表和外表之间各种可能的冲突之后,还应该提到的是,在这个函数与INSERT操作之间也可能发生类似的问题。
-
This registry variable causes the optimizer to favor nested loop joins to join the list of values , using the table that contributes the IN list as the inner table in the join .
这个注册表变量会导致优化器优先使用嵌套循环连接来连接值列表,使用为IN列表提供值的表作为连接的内部表。